: This will start a new import run. The following input form is displayed:
Enter the file name (excluding the path) that requires loading. The system defaults to C:\temp for the correct file, but you can change this with the parameters option.
The data loaded from the in-coming file will not be validated as such. Each in-coming record will be validated to ensure that each record has the correct number of fields and that the amount fields contain only numeric characters.
If the filename entered can not be found the following message will be displayed.
Note
The budget codes in the imported file may match existing budget codes on the system, but do not have to. The imported budget details are not directly related to the budgets shown in AFO 243. There are no links between them. The import is purely for convenience as a way of displaying the financial system view of any funding that they are using. Normally the budget codes should "match".
General information:
· ASCII
· tab delimited fields
· <CR> at end of each record
· price: decimal notation is a “dot”
· date notation: yyyymmdd
Record layout
Field name |
Type |
Description |
Code |
Alphanumeric |
Fund account budget code |
Name |
Alphanumeric |
Fund account name |
Allocation |
Monetary |
Total fund allocation |
Commitment |
Monetary |
Current total outstanding orders committed amount |
Expenditure |
Monetary |
Current total received orders spent amount |
Extract Date |
Date |
Extraction date for these figures |
Notes |
Alphanumeric |
Free format note field |
Note
The login user name and system date will be loaded in addition to the actual data fields taken from the file.
All loaded fiscal data files will be available for display by selecting the icon available on the permanent files management budgets screen (accessed via AFO 243)
All previously loaded files will be shown on a grid screen. Page up and down options will be available along with a delete file option to remove older redundant details.
: Select a previous run and then this option to view the details.
From this screen you can print the imported file. The system will switch to the standard form for generating output. This will result in the same a report as choosing the option on the overview screen.
: This will allow access to the export system level parameters. The following input form will be displayed:
Here you can specify the path name for the files to be imported.
· Document control - Change History
Version |
Date |
Change description |
Author |
1.0 |
unknown |
creation |
|
2.0 |
August 2006 |
updates for release 2.4.1 build 17 |
|